package com.itheima.mapper;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface MemberMapper {
    Member findByTelephone(@Param("telephone")String telephone);

    void add(Member member);

    Integer findMemberCountByMonth(@Param("dateBegin")String dateBegin,@Param("dateEnd") String dateEnd);

    List<Map> querySex();

    List<Integer> getMemberAge();

    List<Map<String, String>> getMemberReportByMonths(@Param("start")String start, @Param("end")String end);

    Integer findTodayMember(@Param("today") String today);

    Integer findTotalMember();

    Integer findNewMemberCountAfterDate(@Param("thisWeekMonday") String thisWeekMonday);
}
